sumif query
 

I have a web query that's working well when I'm importing a single datum into
a cell.
=SUMIF('Query Data'!$E:$E,$B23 & E$1,'Query Data'!$D:$D)

What I need to be able to do is to add the results of the query data of two
separate data (B23 and C23) into a single cell. Sometimes B23 will have data,
sometimes C23 will have data, sometimes both will.

I've tried ($B23+$C23) and ($B23:$C23) but get nothing, even when both have
data. Can someone help?

sumif query
 

Pls give a before and after example with samples so we can understand b23 &
e1. A sumproduct formula will probably do what you want.



--
Don Guillett
SalesAid Software

"mfrasier31" wrote in message
...
I have a web query that's working well when I'm importing a single datum
into
a cell.
=SUMIF('Query Data'!$E:$E,$B23 & E$1,'Query Data'!$D:$D)

What I need to be able to do is to add the results of the query data of
two
separate data (B23 and C23) into a single cell. Sometimes B23 will have
data,
sometimes C23 will have data, sometimes both will.

I've tried ($B23+$C23) and ($B23:$C23) but get nothing, even when both
have
data. Can someone help?